﻿using MigSharp;
using System;
using System.Collections.Generic;

namespace CmsDatabaseMigrations.Migrations
{
    [MigrationExport(ModuleName = "Pages", Tag = "Updates some procedures (cms_sp_PageGetFrontEndPage, cms_sp_PageGetRoutes, cms_sp_PageSelectChildPages, cms_sp_PageSelectParentPages, cms_sp_PageSelectAll, cms_sp_PageRevisionSelectAll, cms_sp_PagePreview, cms_sp_PageGetDraftRevisions, cms_sp_PageGetApprovedRevisions, cms_sp_PageGetActiveRevisions, cms_sp_PageCopy). Add PageKey to select.")]
    public class UspPageGetFrontEndPage201309091643 : BatchMigration
    {
        protected override IEnumerable<string> SpFileNames
        {
            get
            {
                yield return "cms_sp_PageGetFrontEndPage201309091643.sql";
                yield return "cms_sp_PageGetRoutes201309101000.sql";
                yield return "cms_sp_PageSelectChildPages201309100952.sql";
                yield return "cms_sp_PageSelectParentPages201309101013.sql";
                yield return "cms_sp_PageSelectAll201309101022.sql";
                yield return "cms_sp_PageRevisionSelectAll201309101028.sql";
                yield return "cms_sp_PagePreview201309101041.sql";
                yield return "cms_sp_PageGetDraftRevisions201309101044.sql";
                yield return "cms_sp_PageGetApprovedRevisions201309101047.sql";
                yield return "cms_sp_PageGetActiveRevisions201309101050.sql";
                yield return "cms_sp_PageCopy201309101108.sql";
            }
        }

        protected override IEnumerable<Action<IDatabase>> UpActions
        {
            get { return new List<Action<IDatabase>>(); }
        }

        protected override IEnumerable<Action<IDatabase>> DownActions
        {
            get { return new List<Action<IDatabase>>(); }
        }
    }
}